home *** CD-ROM | disk | FTP | other *** search
/ The Macintosh Demo Applications CD / Apple-MacintoshDemoApplicationsCD-1.0-1992.bin / More Information / GQL V3.0 / Open ME! - USA Sales / Open ME! - USA Sales.rsrc / gDEM_8145_Eastern Sales by City < prev    next >
Text File  |  1992-01-27  |  253b  |  1 lines
  1. select customer.cust_city, AVG (orders.ord_amount) from customer, orders where ((customer.cust_state IN ('MI','IN','PA','NY','NH','ME','KY','MA','TN','NC','SC','GA','FL'))) and customer.cust_num = orders.cust_nr group by customer.cust_city order by 1 ;